﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace DAO
{
    public class HoaDonNhapDAO
    {
        public DataTable layBang()
        {
            DataTable dt = new DataTable();
            // tao chuoi ket noi va mo ket noi
            DataProvider dp = new DataProvider();
            OleDbConnection cn = dp.SqlConnect();
            //B3: tao chuoi thao tac csdl
            String strCnn = "select* from Sach ";
            //B4: thuc thi chuoi ket noi
            OleDbDataAdapter da = new OleDbDataAdapter(strCnn, cn);
            da.Fill(dt);
            cn.Close();
            return dt;
        }

    }
}
